Alteryx Academy

A solution to last week’s challenge can be found here.   To solve this week’s challenge, use Designer Cloud or Designer Desktop.   Do you have to reformat lists because the last name and first name are listed in a different order?   In this weekly challenge, you need to rearrange an improperly formatted list of subscribers. Some of the subscribers’ names are listed with the last name(s) followed by a comma, and then the first name(s). Your goal is to reorder the list with the first name(s) followed by the last name(s), and put the list in alphabetical order. For example, the subscriber “BORROEL GOMEZ, JUANA” should be listed as “JUANA BORROEL GOMEZ” with no punctuation.   Note that some subscribers can have more than one first name or last name.   Haven’t heard about Designer Cloud yet? Watch a demo.  ... View more

A solution to last week’s challenge can be found here.   To solve this week’s challenge, use Designer Desktop, Designer Cloud, Designer Experience, or Designer Cloud, Trifacta Classic.   Over the years, Barbie, the doll made by Mattel, has had a lot of different jobs! She has been super busy. Did you know she ran for President of the United States 10 times? Quite impressive!   This dataset complies a list of Barbies that were released from 1959 through 2020. It includes the career name and type of career for that Barbie.   For this challenge, first determine which career Barbie had more than twice between the years 2017 and 2019. Next, calculate by job type how many different types of jobs Barbie held over the years from 1959 through 2020, including the percentage of each.   Data Source: https://data.world/judkacag/barbies-careers-1959-2020  ... View more

A solution to last week’s challenge can be found here.    To solve this week’s challenge, use Designer Desktop or Designer Cloud Trifacta Classic.    According to the Harvard School of Public Health, tea and coffee are the two most consumed beverages on the planet after water. They are brimming with antioxidants and other biologically active substances that may benefit your health.     For this week's challenge, we will use a dataset containing information about the sales of coffee and tea in the USA for a 6-month period.     Based on the sales of each product, determine the following:    Which state is the biggest consumer of regular coffee? Which state is the biggest consumer of decaf coffee? What type of coffee drink is the most popular? Which state is the biggest consumer of regular tea? Which state is the biggest consumer of decaf tea? What type of tea drink is the most popular?   Source: https://data.world/2918diy/coffee-chain  ... View more

  Hi Community members,   A solution to last week’s challenge can be found here.    This challenge for the mathematicians at heart was submitted by Ippei Nakagawa (@gawa). Thank you, Ippei, for this challenge!   The Collatz conjecture, also known as the 3n + 1 problem, is a conjecture in mathematics named after Lothar Collatz, who introduced it in 1937. It is an unsolved problem in mathematics that is simple to state but difficult to prove. The problem is defined as follows: Start with any positive integer N. Apply the following rules: If N is even, divide it by 2. If N is odd, multiply it by 3 and add 1. Repeat the process with the resulting number as much as necessary to reach the number 1. The conjecture states that no matter what positive integer N you start with, you will always eventually reach the number 1.   Here is an example: Start with N=6: 6 is even, so 6/2=3 3 is odd, so 3×3+1=10 10 is even, so 10/2=5 5 is odd, so 5×3+1=16 16 is even, so 16/2=8 8 is even, so 8/2=4 4 is even, so 4/2=2 2 is even, so 2/2=1 A total of 8 steps were required in this example.   For this challenge, you need to create an iterative macro that simulates the repeated steps until reaching 1 for each number. Once the macro is created, your tasks are to: Generate the numbers from 1 to 10,000. Use the iterative macro to apply the Collatz conjecture to each number. Identify the maximum number of steps used to reach the number 1.   Need a refresher? Review the following lessons in Academy to gear up: Introduction to Macros in Designer Types of Macros in Designer Creating an Iterative Macro   Good luck!   The Academy Team   Download Start File   ... View more

  A solution to last week's challenge can be found here.   This challenge comes to us from our ACE @Kenda . Thank you for your contribution, Kenda!   Use Designer Desktop or Designer Cloud, Trifacta Classic to solve this week's challenge.   Father's Day is an annual celebration in the United States, observed on the third Sunday of June. As a result, the exact date of this holiday varies each year, meaning it is not fixed to a specific calendar date.   This week, we are providing a dataset that includes only the year, and your challenge is to determine the exact date on which Father's Day occurs in each year.   Have fun with the challenge and happy Father's Day to all the dads solving this challenge! ... View more